Jump to content

Server Slow Down > Crash

Guest joelle

By Guest joelle
in Classic self-hosted technical help

Recommended Posts

joelle Collaborator

joelle

Posted
Posted

I already asked the IPB.Board support team but they couldn't help me. Since I switched from vbulletin to Invision Power Board I am getting a lot of server crashes. I am definately sure that the error comes from either from IPB.Board, IPB.Blog or from IP.Gallery.


That is part of the error log:

[client 74.6.22.226] PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/joelle.de/httpdocs/modules/blog/lib/lib_cblocks.php on line 658

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[Thu Jul 26 00:12:43 2007] [error] [client 88.73.43.162] File does not exist: /var/www/vhosts/joelle.de/httpdocs/robots.txt

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

[client 66.249.72.239] PHP Warning:  in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173

The slow query log says: 

# Time: 070727 12:58:50

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 28  Lock_time: 13  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=18985;

# Time: 070727 12:58:52

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 188  Lock_time: 172  Rows_sent: 1  Rows_examined: 238

SELECT count(*) as count FROM ibf_topics WHERE approved=1 AND state != 'link' AND forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,658,58,59,60,62,96,402,65,66,68,69,

5,656,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,

59,557,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,62

,630,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141

672,676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,

5,130,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,54,34,36,678,51,64,106

71,20,684,21,632,325,22,668,705,667,669,326,613,624,628,711) AND last_post > '1185414679';

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 26  Lock_time: 9  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=14018;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 80  Lock_time: 63  Rows_sent: 1  Rows_examined: 97

SELECT count(*) as count FROM ibf_topics WHERE approved=1 AND state != 'link' AND forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND last_post > '1185482826';

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 28  Lock_time: 11  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=9915;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 274  Lock_time: 257  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=18561;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 229  Lock_time: 212  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=18249;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 194  Lock_time: 177  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=18923;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 38  Lock_time: 21  Rows_sent: 30  Rows_examined: 144

SELECT * FROM ibf_topics t WHERE t.forum_id=684 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 170  Lock_time: 153  Rows_sent: 30  Rows_examined: 30

SELECT * FROM ibf_topics t WHERE t.forum_id=20 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 39  Lock_time: 22  Rows_sent: 2  Rows_examined: 15917

SELECT tid, title, posts, starter_id as member_id, starter_name as member_name, start_date as post_date, views FROM ibf_topics WHERE forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND  approved=1 and state != 'closed' and (moved_to is null or moved_to = '') ORDER BY start_date DESC LIMIT 0,2;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 202  Lock_time: 185  Rows_sent: 1  Rows_examined: 91

SELECT count(*) as count FROM ibf_topics WHERE approved=1 AND state != 'link' AND forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND last_post > '1185519209';

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 243  Lock_time: 226  Rows_sent: 1  Rows_examined: 0

SELECT * FROM ibf_topics WHERE tid=18559;

# Time: 070727 12:58:56

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 239  Lock_time: 219  Rows_sent: 30  Rows_examined: 205

SELECT * FROM ibf_topics t WHERE t.forum_id=702 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30;

# Time: 070727 12:59:02

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 30  Lock_time: 3  Rows_sent: 30  Rows_examined: 205

SELECT * FROM ibf_topics t WHERE t.forum_id=702 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30;

# Time: 070727 12:59:11

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 31  Lock_time: 0  Rows_sent: 0  Rows_examined: 0

INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('964823c17e477c55b25903071efaab72',1185533920,97,'last_post','desc',1248,'80.131.163.137','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185482826 ORDER BY t.last_post DESC');

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 58  Lock_time: 22  Rows_sent: 2  Rows_examined: 15917

SELECT tid, title, posts, starter_id as member_id, starter_name as member_name, start_date as post_date, views FROM ibf_topics WHERE forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND  approved=1 and state != 'closed' and (moved_to is null or moved_to = '') ORDER BY start_date DESC LIMIT 0,2;

# Time: 070727 12:59:54

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 69  Lock_time: 18  Rows_sent: 1  Rows_examined: 0

SELECT COUNT(*) as cnt FROM ibf_attachments WHERE attach_post_key='efef2de3b9289930328c4428c8a9f251';

# Time: 070727 13:01:59

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 188  Lock_time: 5  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 199  Lock_time: 0  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:00

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 190  Lock_time: 0  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:04

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 173  Lock_time: 0  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 192  Lock_time: 19  Rows_sent: 18  Rows_examined: 18

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'ranks','profilefields','attachtypes','badwords','bbcode','emoticons','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 182  Lock_time: 0  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 192  Lock_time: 19  Rows_sent: 16  Rows_examined: 16

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','attachtypes','multimod','ranks','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 201  Lock_time: 19  Rows_sent: 14  Rows_examined: 14

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'announcements','multimod','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:05

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 193  Lock_time: 18  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 338  Lock_time: 128  Rows_sent: 1  Rows_examined: 1272

SELECT t.*, p.poll_only FROM ibf_topics t  LEFT JOIN ibf_polls p ON ( p.tid=t.tid )   WHERE t.forum_id=669 AND t.tid=13824;

# Time: 070727 13:02:06

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 316  Lock_time: 105  Rows_sent: 1  Rows_examined: 1272

SELECT t.*, p.poll_only FROM ibf_topics t  LEFT JOIN ibf_polls p ON ( p.tid=t.tid )   WHERE t.forum_id=130 AND t.tid=12414;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 205  Lock_time: 21  Rows_sent: 6  Rows_examined: 6

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=3785 AND topic_id IN(7855,15283,15648,16502,17445,18252,18320,18515,18522,18777,18803,18825,18826

18827,18838,18839,18841,18851,18856,18903,18910,18923,18928,18939,18942,18944,18

47,18950,18964,18980);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 184  Lock_time: 1  Rows_sent: 18  Rows_examined: 18

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'ranks','profilefields','attachtypes','badwords','bbcode','emoticons','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 200  Lock_time: 17  Rows_sent: 7  Rows_examined: 7

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=547 AND topic_id IN(3120,7821,7822,10299,13931,18559,18561,18581);

# Time: 070727 13:02:07

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 240  Lock_time: 28  Rows_sent: 1  Rows_examined: 1272

SELECT t.*, p.poll_only FROM ibf_topics t  LEFT JOIN ibf_polls p ON ( p.tid=t.tid )   WHERE t.forum_id=702 AND t.tid=17831;

# Time: 070727 13:02:09

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 207  Lock_time: 14  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 209  Lock_time: 0  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 200  Lock_time: 21  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 170  Lock_time: 62  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 209  Lock_time: 1  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 203  Lock_time: 17  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 207  Lock_time: 14  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# Time: 070727 13:02:15

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 210  Lock_time: 17  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 212  Lock_time: 28  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 172  Lock_time: 77  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# Time: 070727 13:02:16

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 214  Lock_time: 14  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 216  Lock_time: 10  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 216  Lock_time: 0  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 187  Lock_time: 53  Rows_sent: 2945  Rows_examined: 2945

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748

,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1

889,18951,18952,18959);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 200  Lock_time: 3  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:26

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 218  Lock_time: 17  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 210  Lock_time: 15  Rows_sent: 12  Rows_examined: 12

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 226  Lock_time: 0  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 224  Lock_time: 14  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:27

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 223  Lock_time: 18  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 215  Lock_time: 18  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 223  Lock_time: 18  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 208  Lock_time: 12  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 211  Lock_time: 15  Rows_sent: 18  Rows_examined: 18

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','badwords','multimod','ranks','profilefields' );

# Time: 070727 13:02:29

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 320  Lock_time: 86  Rows_sent: 1  Rows_examined: 3

SELECT t.*,p.* FROM ibf_topics t,ibf_posts p WHERE t.starter_id=4091 AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.approved=1 AND t.topic_firstpost=p.pid ORDER BY t.start_date DESC LIMIT 0,5;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 226  Lock_time: 19  Rows_sent: 14  Rows_examined: 14

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'announcements','multimod','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 217  Lock_time: 19  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 217  Lock_time: 19  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 388  Lock_time: 155  Rows_sent: 1  Rows_examined: 1272

SELECT t.*, p.poll_only FROM ibf_topics t  LEFT JOIN ibf_polls p ON ( p.tid=t.tid )   WHERE t.forum_id=80 AND t.tid=9795;

# Time: 070727 13:02:30

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 227  Lock_time: 18  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 229  Lock_time: 9  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:31

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 215  Lock_time: 15  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 215  Lock_time: 15  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 456  Lock_time: 220  Rows_sent: 1  Rows_examined: 1272

SELECT t.*, p.poll_only FROM ibf_topics t  LEFT JOIN ibf_polls p ON ( p.tid=t.tid )   WHERE t.forum_id=543 AND t.tid=18249;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 229  Lock_time: 28  Rows_sent: 20  Rows_examined: 20

SELECT typed,image,clickable,emo_set FROM ibf_emoticons;

# Time: 070727 13:02:34

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 214  Lock_time: 11  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 221  Lock_time: 18  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 230  Lock_time: 27  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 218  Lock_time: 15  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 225  Lock_time: 21  Rows_sent: 0  Rows_examined: 0

INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('116facc3f775589680022b2f9c684e92',1185533925,97,'last_post','desc',1248,'80.131.163.137','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185482826 ORDER BY t.last_post DESC');

# User@Host: port_startf[port_startf] @ localhost []

# Query_time: 212  Lock_time: 0  Rows_sent: 1  Rows_examined: 0

use port_dru;

SELECT data, created, headers, expire FROM cache WHERE cid = 'variables';

# Time: 070727 13:02:35

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 232  Lock_time: 18  Rows_sent: 15  Rows_examined: 15

use joel_ipb;

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' );

# Time: 070727 13:02:38

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 164  Lock_time: 2  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 234  Lock_time: 70  Rows_sent: 16  Rows_examined: 16

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','attachtypes','multimod','ranks','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:39

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 215  Lock_time: 52  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 230  Lock_time: 16  Rows_sent: 2  Rows_examined: 2

SELECT author_id, topic_id FROM ibf_posts WHERE author_id=547 AND topic_id IN(14858,14879,18644,18645,18646,18647,18707,18752,18985);

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 214  Lock_time: 53  Rows_sent: 15  Rows_examined: 15

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:44

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 217  Lock_time: 53  Rows_sent: 1  Rows_examined: 2

SELECT s.member_id, s.member_name, s.member_group, s.id, s.login_type, s.location, s.running_time,t.forum_id FROM ibf_sessions s  LEFT JOIN ibf_topics t ON ( t.tid=s.location_1_id )   WHERE s.location_2_type='forum' AND s.location_2_id=543 AND s.running_time > 1185533047		AND s.in_error=0;

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 218  Lock_time: 52  Rows_sent: 19  Rows_examined: 19

SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 234  Lock_time: 64  Rows_sent: 0  Rows_examined: 0

INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('02cc310fb5680bd21011cb28fc4fa4f2',1185533927,238,'last_post','desc',547,'78.48.41.71','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,658,58,59,60,62,96,402,65,66,68,69,

5,656,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,

59,557,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,62

,630,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141

672,676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,

5,130,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,54,34,36,678,51,64,106

71,20,684,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185414679 ORDER BY t.last_post DESC');

# Time: 070727 13:02:45

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 233  Lock_time: 69  Rows_sent: 0  Rows_examined: 0

INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('816f7e20c4859ece76fa39a2bc1a2e66',1185533921,97,'last_post','desc',1248,'80.131.163.137','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6

6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559,

57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63

,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672

676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1

0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20,

84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185482826 ORDER BY t.last_post DESC');

# User@Host: joel_port[joel_port] @ localhost []

# Query_time: 221  Lock_time: 57  Rows_sent: 0  Rows_examined: 0

INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('19f638d7855b968622c06b93a1385e25',1185533933,238,'last_post','desc',547,'78.48.41.71','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68

,698,689,703,695,406,617,117,103,670,633,710,658,58,59,60,62,96,402,65,66,68,69,

5,656,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,

59,557,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,62

,630,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141

672,676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,

5,130,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,54,34,36,678,51,64,106

71,20,684,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185414679 ORDER BY t.last_post DESC');

Link to comment
Share on other sites
bfarber Grand Master

bfarber

Posted
Posted

Some of those queries just absolutely shouldn't be taking that long. For example

# User@Host: joel_port[joel_port] @ localhost [] # Query_time: 164 Lock_time: 2 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );

# Time: 070727 13:02:38




Let's take a look at this . The query took 164 seconds to run (which is just ridiculous - no one would wait 3 minutes for a page to load these days). Now, it was LOCKED for 2 seconds, so it actually took 162 seconds for mysql to process the query.

Why? It's an optimized query pulling 15 rows from a database table, using an index. There's just no way on earth it should take that long.

Try going to phpmyadmin and running this query

explain SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );



Does it come back fast? What does it say?

What kind of server do you have (processor, memory, dedicated/vps/shared)? If it's dedicated or vps can you post your my.cnf file, and also how many active users (within 15 minutes, shown at the bottom of your board) do you have? How many total topics and posts?

Link to comment
Share on other sites
joelle Collaborator

joelle

Posted
Posted

It came back pretty fast. But I have to admit that I restarted the server 15 minutes ago because the response time of our site was unexeptable.
This is what I received:

 id	   select_type	   table	   type	   possible_keys	   key	   key_len	   ref	   rows	   Extra

1 	SIMPLE 	ibf_cache_store 	range 	PRIMARY 	PRIMARY 	765 	NULL 	16 	Using where

Specs: CPU - AuthenticAMD, AMD Athlon 64 Processor 3000+ OS - os_CentOS 4.2 Memory - 1GB Dedicated Usually I got around 150 active users with guests included. But from time to time I got around 500 active users. The server can easly handle that amount of users. Posts: 370 000 Topics: 16 000 my.cnf 

[mysqld]

set-variable=local-infile=0

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1


set-variable = max_connections=450

set-variable = key_buffer=16M

set-variable = join_buffer=1M

set-variable = record_buffer=1M

set-variable = sort_buffer=2M

set-variable = table_cache=1024

set-variable = thread_cache_size=256

set-variable = wait_timeout=9600

set-variable = connect_timeout=10

set-variable = max_allowed_packet=16M

set-variable = max_connect_errors=10


log-slow-queries=/var/log/mysql/log-slow-queries.log


[mysql.server]

user=mysql

basedir=/var/lib


[mysqld_safe]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid



A single bad/unindexed query can bring a server to its knees but I can't localize the bottleneck, bad file or bad query which causes this server slow down/crash. After I imported the vbulletin database into the IPB.Board database the permission sets were a little mixed up but I am not sure if the transition causes the slow queries.

Link to comment
Share on other sites
bfarber Grand Master

bfarber

Posted
Posted

Firstly, I think you'd have trouble handling 500 users with 1 GB of RAM. I think 150 is fair, but your peaks are going to be hard to handle with only 1GB, depending on what all those visitors are doing.

Secondly, the index appears to be used for that query, yet it shows up a few times in your slow query log, so I'm leaning towards the issue not being an index. You can check your indexes in the ACP under the Support tab in IPB - if any are missing you can create them (or get the query to create them).

I think a few changes in your mysql variables would help, but first I'd need to know if you intend to add some more memory or not. Even 1GB more would make a world of difference, but if you put a total of 4GB in the server, you could likely handle closer to 800-900 without any issues.

At 1GB of memory I'd recommend upping the key_buffer to 256M, setting wait_timeout to 30. There might be a few other changes that would help, but probably not as much as the key_buffer change (which generally should be set to 25-50% of the system's memory).

I assume there aren't any other sites on the server that should be factored in?

Also, these are myisam tables right? innodb is good in some cases, but probably not with your current setup. And search you should be sure is using fulltext search method.

Link to comment
Share on other sites
joelle Collaborator

joelle

Posted
Posted

I am not planing on upgrading the server hardware within the next couple months. When I used vbulletin with the same server specs I had no server slow down problems at all, so I am pretty sure that the current server specs can handle the traffic. At the moment, the IP.Blog & the IP.Gallery response time is fast and the IP.Board is very slow, which is very strange. There are only 50 guests and 30 members online.

Yes, they are myisam tables and no other sites. All the index appear to be fine.

The ACP error log says:

===================================================


Date: Tue, 31 Jul 2007 19:48:09 +0200


Error Number: 1062


Error: Duplicate entry '486-2683' for key 1


IP Address: 80.143.95.162


mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for


m_id) VALUES(1671,'a:1:{i:16899;i:1185904089;}',1185904089,2683,486)


===================================================


Date: Tue, 31 Jul 2007 20:13:23 +0200


Error Number: 1062


Error: Duplicate entry '636-2683' for key 1


IP Address: 80.143.95.162


mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for


m_id) VALUES(280,'a:0:{}',1185905600,2683,636)


===================================================


Date: Tue, 31 Jul 2007 20:20:53 +0200


Error Number: 1062


Error: Duplicate entry '84-1840' for key 1


IP Address: 78.48.152.34


mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for


m_id) VALUES(33,'a:0:{}',1185906052,1840,84)


===================================================


Date: Tue, 31 Jul 2007 20:57:52 +0200


Error Number: 1062


Error: Duplicate entry '71-3955' for key 1


IP Address: 85.177.179.236


mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for


m_id) VALUES(9,'a:0:{}',1185908270,3955,71)


===================================================


Date: Tue, 31 Jul 2007 20:57:52 +0200


Error Number: 1062


Error: Duplicate entry '71-3955' for key 1


IP Address: 85.177.179.236


mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for


m_id) VALUES(9,'a:0:{}',1185908270,3955,71)


===================================================


Date: Tue, 31 Jul 2007 20:57:52 +0200


Error Number: 1062


Error: Duplicate entry '71-3955' for key 1


IP Address: 85.177.179.236


mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for


m_id) VALUES(9,'a:0:{}',1185908270,3955,71)

Link to comment
Share on other sites
bfarber Grand Master

bfarber

Posted
Posted

80 users should be fine on those specs - I was just pointing out your peak traffic.

As Blair said, you need to increase the key_buffer size.

The rule of thumb I go with is to start around 25% of total memory. Now, MySQL and webserver are on one server it sounds like so you may want to start lower (128M will be an improvement over 16M even) but you can increment it higher if you find your server can handle it.

Another thing you can check is to run this query

SHOW STATUS LIKE '%key_read%';



Key_read_requests / key_reads should be right somewhere around 1000 to 1.

For example, here's the data for IPS Beyond presently

Key_read_requests 1081257869
Key_reads 2621032

It's about 412 to 1. This tells me I could probably get better performance with tweaking the key_buffer (which is set to 8M here, the default).

(Heck, actually now that I bothered to take the time to do that, I might ssh in tomorrow and try to update it.)

Link to comment
Share on other sites
njustice Newbie

njustice

Posted
Posted

I'm no MySQL expert, and I don't play one on TV, but I have spent enough tweaking my servers to learn enough to be dangerous... You may not need to do anything other than your last edit, increasing your key_buffer to 128MB.

QUERY CACHE


Query cache is supported but not enabled


Perhaps you should set the query_cache_size


Maybe start with this:
query_cache_limit=4M
query_cache_size=1M
query_cache_type=1

MAX CONNECTIONS


Current max_connections = 400


Seems like a lot for 1GB RAM. Lower to 150, or less.

KEY BUFFER


Current MyISAM index space = 237 M


Your key buffer should probably be around 256MB. Another GB of RAM would help, A LOT.

TEMP TABLES


Current max_heap_table_size = 16 M


Current tmp_table_size = 32 M


I never specifiy max_heap_table_size, but I'm guessing it should be equal to tmp_table_size. I'd try doubling the tmp_table_size to 64M. 128M may be ideal, but you're memory limited.

TABLE LOCKING


Current Lock Wait ratio = 1 : 1347


You may benefit from selective use of InnoDB.


Brandon has said these can safely be changed to InnoDB, and may help with locking on some busy sites:
ibf_cache_store (change ibf_ if you've used a different prefix)
ibf_topic_markers

A couple other tweaks to add to my.cnf:
key_cache_division_limit=40
low_priority_updates=1

This tuning script is dynamic. You want to make some changes, let it run a couple of days and then run again. Keep tweaking until you get the optimal config. You will also need to rerun and change as your database grows. Your current server may have handled vBulletin, but your database is continually growing, and you would have likely had the same problems with it. Really, the best thing you could do is add another 1GB of RAM.

A couple other things it could be. A search on a very popular word, or maybe a cron for your server processing stats.
Link to comment
Share on other sites
bfarber Grand Master

bfarber

Posted
Posted

Yes, the InnoDB tables Blair mentioned are fine - especially the topic_markers. If you have any caching software (such as eaccelerator or xcache, for example) you can actually use those too with IPB - which pulls a little load off of the database server at much higher speeds.

The key_buffer_size is the key really. I'd go with 25% of the system memory (at least) if mysql seems to be the CPU/Memory hog. It's maxing out it's available resources and swapping. With a site your size, that's easy to do (250,000+ posts).


My recommendation - add another 1 GB (or 3GB, for room to grow) of RAM. It's really not too expensive. You can get RAM from places like NewEgg for cheap a lot of times. There's a stick of ECC Unbuffered Kingston RAM (and one of Crucial), 1 GB, for under $50 on NewEgg right now with under $5 shipping. I've heard of hosts offering an extra stick of RAM to be added to a server for as little as $15 one time fee (of course you don't own it, but still). It's going to make a huge impact, and as Blair said - you would have hit the same problems in vBulletin. You may not have hit them yet, but you would have, and it wouldn't have taken very long.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
Invision Community © 2024 IPS, Inc.
×
×
  • Create New...